Skip to main content

COUNT

Counts the number of elements in an array.

Description​

Returns the number of elements within a given array or range.

Syntax​

COUNT(array)

Arguments​

  • array: The array or range of cells to count the elements of.

Example​

COUNT(A1:A5) → Returns the number of elements in the range A1 to A5.
COUNT([1, 2, 3, 4, 5]) → Returns 5.
COUNT([]) → Returns 0.

Usage Notes:

  • This function counts all elements in the provided array or range, regardless of their data type.
  • Empty arrays or ranges will return 0.